FaFISAPVarianceDetails

EntityType | Independent
Logical Entity Name | FaFISAPVarianceDetails
Default Table Name | FaFISAPVarianceDetails
Logical Only | NO
Owner | dbo
Definition |
Note |

FaFISAPVarianceDetails Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaFISAPVarianceDetailsID |  | INTEGER | NO |
BatchIdentifier |  | UNIQUEID | NO |
LastName |  | VARCHAR(25) | YES |
FirstName |  | VARCHAR(25) | YES |
MI |  | VARCHAR(1) | YES |
SSN |  | VARCHAR(30) | YES |
Model |  | CHAR(1) | YES |
SyStudentID |  | INTEGER | YES |
SyCampusID |  | INTEGER | YES |
AwardYear |  | VARCHAR(7) | YES |
CampusCode |  | CHAR(8) | YES |
CampusDescription |  | VARCHAR(50) | YES |
FISAPIncome |  | INTEGER | YES |
DetailPerkins |  | MONEY(19, 4) | YES |
DetailSEOG |  | MONEY(19, 4) | YES |
DetailWorkst |  | MONEY(19, 4) | YES |
CashPerkins |  | MONEY(19, 4) | YES |
CashSEOG |  | MONEY(19, 4) | YES |
CashWorkst |  | MONEY(19, 4) | YES |
VarPerkins |  | MONEY(19, 4) | YES |
VarSEOG |  | MONEY(19, 4) | YES |
VarWorkst |  | MONEY(19, 4) | YES |
DateAdded |  | DATETIME | YES |
DateLstMod |  | DATETIME | YES |
UserID |  | INTEGER | NO |
ts |  | TIMESTAMP/DATE | NO |

FaFISAPVarianceDetails Keys

Key Name | Key Type | Keys
FaFISAPVarianceDetails_BatchIdentifier_FaFISAPVarianceDetailsID_U_N_IDX | Alternate Key | BatchIdentifier, FaFISAPVarianceDetailsID
PK_FaFISAPVarianceDetails_FaFISAPVarianceDetailsID | PrimaryKey | FaFISAPVarianceDetailsID

FaFISAPVarianceDetails Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaFISAPVarianceDetails Check Constraints

Check Constraint Name | CheckConstraint

FaFISAPVarianceDetails Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaFISAPVarianceDetails | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaFISAPVarianceDetails | NO |  |  |

FaFISAPVarianceDetails Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaFISAPVarianceDetails Data Movement Rules

Name | Type | Rule Text/Value